CREATE VIEW [dbo].[vSoaPendingCashPaymentAdjustment] WITH SCHEMABINDING
AS
SELECT [ST_ID],
       [PRODUCT_CODE],
       SUM(-([AMOUNT] + [ADJUSTMENT_AMOUNT])) AS Amount,
       COUNT_BIG(*) [Count]
  FROM [dbo].Trans
  WHERE [POSTED] < 2 AND [TRANSACTION_TYPE] = 'DIST' AND [JOURNAL_TYPE] = 'PAY' AND [INVOICE_REFERENCE_NUM] = 0
  GROUP BY [ST_ID], [PRODUCT_CODE]

GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaPendingCashPaymentAdjustment] ON [dbo].[vSoaPendingCashPaymentAdjustment] ([ST_ID], [PRODUCT_CODE]) ON [PRIMARY]
GO